{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                   timestamp         featureName  componentType  \\\n",
      "0   2018-08-08T06:08:03.390Z  Tel_Callin_IVR_End            IVR   \n",
      "1   2018-08-08T06:08:03.332Z  Tel_Callin_IVR_End            IVR   \n",
      "2   2018-08-08T06:08:03.211Z  Tel_Callin_IVR_End            IVR   \n",
      "3   2018-08-08T06:07:55.706Z  Tel_Callin_IVR_End            IVR   \n",
      "4   2018-08-08T06:07:55.525Z  Tel_Callin_IVR_End            IVR   \n",
      "5   2018-08-08T06:07:55.625Z  Tel_Callin_IVR_End            IVR   \n",
      "6   2018-08-08T06:07:53.579Z  Tel_Callin_IVR_End            IVR   \n",
      "7   2018-08-08T06:07:48.208Z  Tel_Callin_IVR_End            IVR   \n",
      "8   2018-08-08T06:07:48.411Z  Tel_Callin_IVR_End            IVR   \n",
      "9   2018-08-08T06:07:48.308Z  Tel_Callin_IVR_End            IVR   \n",
      "10  2018-08-08T07:43:32.998Z  Tel_Callin_IVR_End            IVR   \n",
      "11  2018-08-08T07:43:32.417Z  Tel_Callin_IVR_End            IVR   \n",
      "12  2018-08-08T07:43:32.163Z  Tel_Callin_IVR_End            IVR   \n",
      "13  2018-08-08T07:43:32.112Z  Tel_Callin_IVR_End            IVR   \n",
      "14  2018-08-08T07:43:28.534Z  Tel_Callin_IVR_End            IVR   \n",
      "15  2018-08-08T07:43:26.619Z  Tel_Callin_IVR_End            IVR   \n",
      "16  2018-08-08T07:43:24.843Z  Tel_Callin_IVR_End            IVR   \n",
      "17  2018-08-08T07:43:22.267Z  Tel_Callin_IVR_End            IVR   \n",
      "18  2018-08-08T07:43:21.976Z  Tel_Callin_IVR_End            IVR   \n",
      "19  2018-08-08T07:43:16.056Z  Tel_Callin_IVR_End            IVR   \n",
      "20  2018-08-08T07:43:56.509Z  Tel_Callin_IVR_End            IVR   \n",
      "21  2018-08-08T07:43:48.418Z  Tel_Callin_IVR_End            IVR   \n",
      "22  2018-08-08T07:43:33.675Z  Tel_Callin_IVR_End            IVR   \n",
      "23  2018-08-08T07:43:33.428Z  Tel_Callin_IVR_End            IVR   \n",
      "24  2018-08-08T07:43:33.477Z  Tel_Callin_IVR_End            IVR   \n",
      "25  2018-08-08T07:43:26.010Z  Tel_Callin_IVR_End            IVR   \n",
      "26  2018-08-08T07:43:26.111Z  Tel_Callin_IVR_End            IVR   \n",
      "27  2018-08-08T07:43:26.258Z  Tel_Callin_IVR_End            IVR   \n",
      "28  2018-08-08T07:43:21.014Z  Tel_Callin_IVR_End            IVR   \n",
      "29  2018-08-08T07:43:20.526Z  Tel_Callin_IVR_End            IVR   \n",
      "30  2018-08-08T07:44:28.158Z  Tel_Callin_IVR_End            IVR   \n",
      "31  2018-08-08T07:44:18.843Z  Tel_Callin_IVR_End            IVR   \n",
      "32  2018-08-08T07:43:57.307Z  Tel_Callin_IVR_End            IVR   \n",
      "33  2018-08-08T07:43:37.627Z  Tel_Callin_IVR_End            IVR   \n",
      "34  2018-08-08T07:43:37.387Z  Tel_Callin_IVR_End            IVR   \n",
      "35  2018-08-08T07:43:37.488Z  Tel_Callin_IVR_End            IVR   \n",
      "36  2018-08-08T07:43:36.470Z  Tel_Callin_IVR_End            IVR   \n",
      "37  2018-08-08T07:43:35.703Z  Tel_Callin_IVR_End            IVR   \n",
      "38  2018-08-08T07:43:22.487Z  Tel_Callin_IVR_End            IVR   \n",
      "39  2018-08-08T07:43:21.373Z  Tel_Callin_IVR_End            IVR   \n",
      "\n",
      "    componentAddress  poolName   isSuccess               failReason  \n",
      "0      10.120.232.14     t01sj       False             User hang up  \n",
      "1      10.120.232.14     t01sj       False             User hang up  \n",
      "2      10.120.232.14     t01sj       False             User hang up  \n",
      "3      10.120.232.13     t01sj       False             User hang up  \n",
      "4      10.120.232.13     t01sj       False             User hang up  \n",
      "5      10.120.232.13     t01sj       False             User hang up  \n",
      "6      10.120.232.11     t01sj       False  Unexpected sip.RESPONSE  \n",
      "7      10.120.232.12     t01sj       False             User hang up  \n",
      "8      10.120.232.12     t01sj       False             User hang up  \n",
      "9      10.120.232.12     t01sj       False             User hang up  \n",
      "10     10.121.223.14     t01ln       False             User hang up  \n",
      "11     10.121.223.23     t01ln       False             User hang up  \n",
      "12     10.121.223.19     t01ln       False     Authenticate failure  \n",
      "13     10.121.223.19     t01ln       False             User hang up  \n",
      "14     10.121.223.23     t01ln       False             User hang up  \n",
      "15     10.121.223.17     t01ln       False             User hang up  \n",
      "16     10.121.223.12     t01ln       False  Unexpected sip.RESPONSE  \n",
      "17     10.121.223.20     t01ln       False             User hang up  \n",
      "18     10.121.223.15     t01ln       False             User hang up  \n",
      "19     10.121.223.12     t01ln       False             User hang up  \n",
      "20     10.120.123.31     t01am       False  Unexpected sip.RESPONSE  \n",
      "21     10.120.123.25     t01am       False  Unexpected sip.RESPONSE  \n",
      "22     10.120.123.31     t01am       False             User hang up  \n",
      "23     10.120.123.31     t01am       False             User hang up  \n",
      "24     10.120.123.31     t01am       False             User hang up  \n",
      "25     10.120.123.30     t01am       False             User hang up  \n",
      "26     10.120.123.30     t01am       False             User hang up  \n",
      "27     10.120.123.30     t01am       False             User hang up  \n",
      "28     10.120.123.19     t01am       False  Unexpected sip.RESPONSE  \n",
      "29     10.120.123.11     t01am       False  Unexpected sip.RESPONSE  \n",
      "30      10.121.146.7     t01sg       False             User hang up  \n",
      "31      10.121.146.6     t01sg       False             User hang up  \n",
      "32      10.121.146.5     t01sg       False             User hang up  \n",
      "33      10.121.146.8     t01sg       False             User hang up  \n",
      "34      10.121.146.8     t01sg       False             User hang up  \n",
      "35      10.121.146.8     t01sg       False             User hang up  \n",
      "36      10.121.146.7     t01sg       False             User hang up  \n",
      "37      10.121.146.5     t01sg       False             User hang up  \n",
      "38      10.121.146.6     t01sg       False             User hang up  \n",
      "39     10.121.146.10     t01sg       False             User hang up  \n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAE1CAYAAAD3ZxuaAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAFfRJREFUeJzt3XuwZWV95vHvAw2CUQTCgRCQaUOA\ngSLQmB4kAVFBBwImwgxqKKUwkrTEMCWOmqGYzICGMWhAUlMaDAaQeEFRYcCRMWoHhngZSIMtFzvI\nRRK5DHSHqwOCdP/mj7VOcmjP4dz27t39nu+natdee+219vqdqvc8Z513v+tdqSokSZu+zUZdgCRp\nMAx0SWqEgS5JjTDQJakRBrokNcJAl6RGGOiS1AgDXZIaYaBLUiMWbciD7bDDDrV48eINeUhJ2uTd\neOONa6pqbLrtNmigL168mBUrVmzIQ0rSJi/JP8xkO7tcJKkRBrokNcJAl6RGGOiS1AgDXZIaMW2g\nJ9kqyQ1JvpfktiTv79e/LMn1Se5I8vkkWw6/XEnSVGZyhv40cFhV7Q8sAY5MchDwIeC8qtoDeAQ4\naXhlSpKmM22gV+fH/cst+kcBhwFf7NdfAhwzlAolSTMyoz70JJsnWQk8BHwduAt4tKqe7Te5F9hl\nOCVKkmZiRleKVtVaYEmSbYErgL0n22yyfZMsA5YB7LbbbnMsUxLA4tO+MuoSmnLP2UePuoSBmtUo\nl6p6FLgWOAjYNsn4H4Rdgfun2OeCqlpaVUvHxqadikCSNEczGeUy1p+Zk2Rr4LXAKuAa4Lh+sxOB\nK4dVpCRpejPpctkZuCTJ5nR/AC6rqv+Z5PvA55KcBXwXuHCIdUqSpjFtoFfVzcABk6y/GzhwGEVJ\nkmbPK0UlqREGuiQ1wkCXpEYY6JLUCANdkhphoEtSIwx0SWqEgS5JjTDQJakRBrokNcJAl6RGGOiS\n1AgDXZIaYaBLUiMMdElqhIEuSY0w0CWpEQa6JDXCQJekRhjoktQIA12SGmGgS1IjDHRJaoSBLkmN\nMNAlqREGuiQ1YtpAT/LSJNckWZXktiTv6tefmeS+JCv7x1HDL1eSNJVFM9jmWeA9VXVTkhcDNyb5\nev/eeVV1zvDKkyTN1LSBXlUPAA/0y08kWQXsMuzCJEmzM6s+9CSLgQOA6/tVpyS5OclFSbabYp9l\nSVYkWbF69ep5FStJmtqMAz3Ji4AvAadW1ePA+cDuwBK6M/hzJ9uvqi6oqqVVtXRsbGwAJUuSJjOj\nQE+yBV2Yf6aqLgeoqgeram1VrQM+ARw4vDIlSdOZySiXABcCq6rqIxPW7zxhs2OBWwdfniRppmYy\nyuVg4ATgliQr+3WnA8cnWQIUcA/wjqFUKEmakZmMcvkmkEneunrw5UiS5sorRSWpEQa6JDXCQJek\nRhjoktQIA12SGmGgS1IjDHRJaoSBLkmNMNAlqREGuiQ1wkCXpEYY6JLUCANdkhphoEtSIwx0SWqE\ngS5JjTDQJakRBrokNcJAl6RGGOiS1AgDXZIaYaBLUiMMdElqhIEuSY0w0CWpEdMGepKXJrkmyaok\ntyV5V79++yRfT3JH/7zd8MuVJE1lJmfozwLvqaq9gYOAP0iyD3AasLyq9gCW968lSSMybaBX1QNV\ndVO//ASwCtgFeANwSb/ZJcAxwypSkjS9WfWhJ1kMHABcD+xUVQ9AF/rAjoMuTpI0czMO9CQvAr4E\nnFpVj89iv2VJViRZsXr16rnUKEmagRkFepIt6ML8M1V1eb/6wSQ79+/vDDw02b5VdUFVLa2qpWNj\nY4OoWZI0iZmMcglwIbCqqj4y4a2rgBP75ROBKwdfniRpphbNYJuDgROAW5Ks7NedDpwNXJbkJOAf\ngTcOp0RJ0kxMG+hV9U0gU7x9+GDLkSTNlVeKSlIjDHRJaoSBLkmNMNAlqREGuiQ1wkCXpEYY6JLU\nCANdkhphoEtSIwx0SWqEgS5JjTDQJakRBrokNcJAl6RGGOiS1AgDXZIaYaBLUiMMdElqhIEuSY0w\n0CWpEQa6JDXCQJekRhjoktQIA12SGmGgS1IjDHRJasS0gZ7koiQPJbl1wrozk9yXZGX/OGq4ZUqS\npjOTM/RPAkdOsv68qlrSP64ebFmSpNmaNtCr6jrg4Q1QiyRpHubTh35Kkpv7LpntptooybIkK5Ks\nWL169TwOJ0l6PnMN9POB3YElwAPAuVNtWFUXVNXSqlo6NjY2x8NJkqYzp0Cvqgeram1VrQM+ARw4\n2LIkSbM1p0BPsvOEl8cCt061rSRpw1g03QZJLgVeDeyQ5F7gDODVSZYABdwDvGOINUqSZmDaQK+q\n4ydZfeEQapEkzYNXikpSIwx0SWqEgS5JjTDQJakRBrokNcJAl6RGGOiS1AgDXZIaYaBLUiMMdElq\nhIEuSY0w0CWpEQa6JDXCQJekRhjoktQIA12SGmGgS1IjDHRJaoSBLkmNMNAlqREGuiQ1wkCXpEYY\n6JLUCANdkhphoEtSI6YN9CQXJXkoya0T1m2f5OtJ7uiftxtumZKk6czkDP2TwJHrrTsNWF5VewDL\n+9eSpBGaNtCr6jrg4fVWvwG4pF++BDhmwHVJkmZprn3oO1XVAwD9846DK0mSNBeLhn2AJMuAZQC7\n7bbbsA83EItP+8qoS2jKPWcfPeoSpAVhrmfoDybZGaB/fmiqDavqgqpaWlVLx8bG5ng4SdJ05hro\nVwEn9ssnAlcOphxJ0lzNZNjipcB3gL2S3JvkJOBs4HVJ7gBe17+WJI3QtH3oVXX8FG8dPuBaJEnz\n4JWiktQIA12SGmGgS1IjDHRJaoSBLkmNMNAlqREGuiQ1wkCXpEYY6JLUCANdkhphoEtSIwx0SWqE\ngS5JjTDQJakRBrokNcJAl6RGGOiS1AgDXZIaYaBLUiMMdElqhIEuSY0w0CWpEQa6JDXCQJekRhjo\nktQIA12SGrFoPjsnuQd4AlgLPFtVSwdRlCRp9uYV6L3XVNWaAXyOJGke7HKRpEbMN9AL+FqSG5Ms\nm2yDJMuSrEiyYvXq1fM8nCRpKvMN9IOr6uXAbwB/kOTQ9TeoqguqamlVLR0bG5vn4SRJU5lXoFfV\n/f3zQ8AVwIGDKEqSNHtzDvQkP5fkxePLwL8Fbh1UYZKk2ZnPKJedgCuSjH/OZ6vqqwOpSpI0a3MO\n9Kq6G9h/gLVIkubBYYuS1AgDXZIaYaBLUiMMdElqhIEuSY0w0CWpEQa6JDXCQJekRhjoktQIA12S\nGmGgS1IjDHRJaoSBLkmNMNAlqREGuiQ1wkCXpEYY6JLUCANdkhphoEtSIwx0SWqEgS5JjTDQJakR\nBrokNcJAl6RGGOiS1Ih5BXqSI5PcnuTOJKcNqihJ0uzNOdCTbA58DPgNYB/g+CT7DKowSdLszOcM\n/UDgzqq6u6qeAT4HvGEwZUmSZms+gb4L8KMJr+/t10mSRmDRPPbNJOvqZzZKlgHL+pc/TnL7PI6p\n59oBWDPqIqaTD426Ao2AbXOw/tVMNppPoN8LvHTC612B+9ffqKouAC6Yx3E0hSQrqmrpqOuQ1mfb\nHI35dLn8HbBHkpcl2RL4beCqwZQlSZqtOZ+hV9WzSU4B/hrYHLioqm4bWGWSpFmZT5cLVXU1cPWA\natHs2ZWljZVtcwRS9TPfY0qSNkFe+i9JjTDQJakRBrrmJcmOSV4y6jqk9S3Etmmga86SnAWsBC5M\n8oejrkcat1Db5rxGuWjhSnIA8Kt00z3sCfxFkruAq6vqqZEWpwVtIbdNz9A1Y0l2mvDySWBb4MVV\ndTtwMXAY8CujqE0Lm22zY6BrWkm2S/IZ4Ook7+/PgNYAK4Al/Waf7Z8PSGK70gZh23yupn84Dcwp\nwNPA4cDjdGc8j/frXp5kp6r6KfA3wFurat3IKtVCY9ucwEDXlJKMz6j5U+DbVfVoVZ1LdwZ0EnAZ\nsDfwOoCq+hLwVJKxUdSrhcO2OTm/FNWU6l8uI94OmHhm8z7gC8D+wBXAu5PsD7wC+AHw8IasUwtD\nki2r6pkksW1Ozkv/BUA/XvdM4C/Xn2QtyX7Ap4Cjq+reft3ngb+vqjOS/DLd3aqe6KdLlgYmyTbA\n+4GbqupT671n25zALheR5Cjgb4FtgAf76ZBJ8tokb6mqm4HvAH844V/WL9Of7VTVnVV17kL4hdGG\nleRU4H8BbwWOmbDetjkJA30Bm9APuTfwgao6qarW9PeIBfh/wHX98unA9sAZSX4X+CPgwQ1asBaM\nJFsl+S90feDH092IfusJwxOfBK7tl22bPbtcFqAkOwJrxr/xT7Ic+G/Ad4GzgR8CX6mqW/r3U1WV\nZFfgYOBY4NKqunIkP4Ca1Qf2Q317276qHu7XHwqcDLyvqu6bZD/bJgb6gpJkc+Acuj7FbwDfqaqL\nk/w+3bCvzYDlwO503S+XV9XVSV4A7F5V3x9R6Wrcem1zOfC3VfVXSTarqnV9G1wFvLmq/m7CScYW\nwB62zY5dLgvLkXSXQu9BN6zrPyXZF/ge8ELggar6GPBBurP0Pfv93gbslWSzCd000iBNbJufB05P\n8it9mKeqnqYbtXIEPGcE1u9g2/xnBvoCMKGhrwX+CVhXVd+gG951Et3NvZcD+yfZoqrWAL8A/Ljf\n7+KquqKq1pX/0mmAnqdtXgacnGSH/kw8wGPAU/1+40OubZsTGOgLwISG/gK6X5pd+9fnAPvRdbH8\nGXAb3ex0lwIHADf1+z+DNATTtM296CbZGt/ufuDt/etn++efbsh6N3YGeoOSvDvJYUl+sX89fjZz\nHV14/2qSrarqMbp7wr6vqtbSfen058Dyqjqkqm4aRf1q1yza5uN0bfPdE3a/HPhov9+C716ZjIHe\nkCSvTrISeCXdl0sfgO5spv9y6RHgSrrxvOMTF32ebuz5C6vzf6rqL0dRv9o1x7Z5GV3b3Lrf9uGq\nOr9fXvDdK5Px0v9G9LPIvRI4q6q+mOQ1wKsnbgJQVRf2wxbfm+QG4N8D36iqJzd0zVoYBtA2m57D\nfJActrgJS7I93b+pN1XV2iRfpRvadQ7wcWCr/vlrVfVE/4XnT5NsRdd3fjxwc1VdPKIfQY2ybY6G\ngb6J6seOnwncCDwEvJdu6OE7gbfQ9Tf+NfDbwJNVdfJ6kxpJQ2HbHB370DdBSV4IHAT8WlUdBdwL\nnEE3UuCDwFVV9a6qupruCtC9+nmh/YXRUNk2R8tA3wT1/d2/BuzYr/oU3ZCv4+gm9j84yfjttvYF\n7qiqBTm3hTYs2+ZoGeibmP4SaejuzHIsQHX3TbyBbgzvL9D9S/vpJBfRTVx03SQfJQ2UbXP0DPSN\nWJK3JnlVkp/vX6cfLw5wPbB9P2IAusn7dwYWVdUHgHfR/SIdWlWf3tC1q222zY2TwxY3Qv0dVi6i\nu53WfcD/TXJmdXdrWdRfJXcj3bS370hybVXd2fdf7grcVVXX8i/Ti0oDYdvcuHmGvpHpx+weDXy8\nqo6gu9his/HL7/sLMX4J+E26if8BPpfka8CWdGdD0sDZNjd+BvpGIMmiJHsm2bqfo3wf4Kj+7TcA\nS5O8JsmOSX6L7t/VLarqbuBEusv1v1BVh1XVAyP5IdQk2+amxXHoI5bk39FdYPHtftUbgZ+juwDj\nlXRT234F+HXgJ8BZwLP9pdLS0Ng2Nz2eoY9Q36/4W8BvVtUxdMO7zgB+HviPwA1V9aaqugT4BN0X\nS1tX1SMTRhRIA2fb3DQZ6CPUj9ndC9ihX3UusAXdZP8/AbZLcnj/3g7A01X1j/2+a5GGxLa5aTLQ\nRySdzejG5e7bD/v6PnAzsJhulMDXgPOTfBj4MN3dzZ06VENl29x0GegbQJIjkhya7r6IQDf9Z/8l\n0w+BnYBX9W/9b+DlwFNV9d/p5sF4EDiqqv58fN8N+gOoWbbNtjgOfYiSvAz4ZP/yEeC6JOdX1VPj\ns8vR3ax5T+CoJLdU1b1JHqW7t+IPquqqkRSvptk22+QZ+nAdB1xTVa8CPg3sOT63cz9V6A7AgcA1\ndON0P5vkEuBldCMIpGGxbTbIQB+w9b7h34ZueBfAvwF2SnJIku2TvBL4PrBvVX2nqk4Fzge+CxxU\nVfdu0MLVPNtm+xyHPiBJ3kQ3Kf9fVNVX+3U7AOfRXYzxFPAZ4GDgH4DPAo/5y6Fhs20uHJ6hz8P4\nN/pJDgL+M92wrqXpb4BbVWuA99BNEXpIdfdD/Cu6Weee6PskN3NkgAbNtrkwGehzlGTLCd/orwJe\nT3fj2zFgfJY5quoh4Okkr+9XPQJsB/yof3+dIwM0SLbNhctAn4Mk/wG4IckfJ3l9VT1WVT+qqhuA\nu4H9kuzTb7sd3exzZyX5I7q5oq/v3/PsRwNl21zYDPRZSvIq4K3A24HbgDOTHDxhk6/S/Xt7OEA/\nr8VHgT+hGy3wlqr6UD/W17MfDYxtU34pOgNJNh+/nDnJccB+VfVf+9cnA79fVftP2P5NdF823QXs\nXlVnbviqtRDYNjWRZ+jPo5869IPAB5Mc0a9+Fjh0fJuq+ni/7bIJu34TeBPwEWCr/n3/hdXA2DY1\nGQN9Cv2/rzfSfUn0A7p+xkOq6n8AOyc5YcLmp9PfQ7H/5fizfp9/XVWngZdEa3Bsm5qKl/5PbR1w\nTlV9CiDJfnQT+n+Tbg6Ljyb5QlX9BHgAWDV+yXSS36uqx0ZWuVpn29Sk7EOfQrr5oNfSTdi/Nsnx\nwAHAaVW1LsnFwDN08128EXi8qn53dBVrobBtaip2uUyhqp6sqqcnzO18BPCjfhY6gFOBq4A3A7f7\nC6MNxbapqXiGPo1+/ouiu9XWKVV1V5J9gXuq6sf9RRzPjLZKLUS2Ta3PM/TpraMbu7sG2D/Jl+ku\nmV4E4C+MRsi2qefwDH0G+vkwvt0/Lq6qC0dckgTYNvVcBvoMJNkVOAH4SFU9Pep6pHG2TU1koEtS\nI+xDl6RGGOiS1AgDXZIaYaBLUiMMdG3Ukmyb5J398i8m+eIQj7UkyVHD+nxp2Ax0bey2Bd4JUFX3\nV9VxQzzWEsBA1ybLYYvaqCX5HN1MgrcDdwB7V9W+Sd4GHANsDuwLnEt3150TgKeBo6rq4SS7Ax+j\nu5/mk8DvVdXfJ3kjcAbdJFePAa8F7gS2Bu6ju4vPD+mmm90aeAr4naq6fRbHvhZYCRwIbAO8vb8V\nnDQcVeXDx0b7ABYDt06y/Da6AH4xXVg/Bpzcv3cecGq/vBzYo19+BfA3/fItwC798rYTPvOjE469\nDbCoX34t8KVZHvta4BP98qHjtfvwMayH86FrU3ZNVT0BPJHkMeDL/fpb6G6G/CLg14EvTLgpzwv6\n528Bn0xyGXD5FJ//EuCSJHvQTYK1xUyPPWG7SwGq6rok2yTZtqoenePPKz0vA12bsomXuq+b8Hod\nXdveDHi0qpasv2NVnZzkFcDRwMokP7MN8Md0wX1sksV0Z9wzPfY/H2r9Qz/PzyPNi1+KamP3BF3X\nxqxV1ePAD/v+ctLZv1/evaqur+6GymuAl05yrJfQ9adD180yF2/uj3cI8Fh5tyANkYGujVpV/RPw\nrSS3An86h494C3BSku8Bt9F9wQrwp0lu6T/3OuB7wDXAPklWJnkz8GHgT5J8i+4L0Ll4JMm3gY8D\nJ83xM6QZcZSLNCT9KJf3VtWKUdeihcEzdElqhGfoktQIz9AlqREGuiQ1wkCXpEYY6JLUCANdkhph\noEtSI/4/rhLGaCLm9u8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x114a27cf8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "\n",
    "csvFile = '/Users/yafan/Documents/workspace/webex/webex-telephony-metrics/logs/GivrMetricsReporter_2018080815.csv'\n",
    "\n",
    "df = pd.read_csv(csvFile)\n",
    "print(df)\n",
    "\n",
    "df['timestamp'] = pd.to_datetime(df['timestamp'])\n",
    "df1 = df.groupby([df['timestamp'].dt.to_period('H')]).count()\n",
    "df2 = df1['timestamp']\n",
    "df2.plot(kind=\"bar\", rot=30)\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
